package com.gaoxin.api.dao.studao;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import com.gaoxin.api.entity.stuentity.DormInfoEntity;
import com.gaoxin.api.entity.stuentity.FamilyInfoEntity;
import com.gaoxin.api.entity.stuentity.SchoolInfoEntity;
import com.gaoxin.api.entity.stuentity.StuInfoEntity;

/**
 * 学生系统接口-数据访问层
 *
 * @author fanyue
 * @email 859485490@qq.com
 * @date 2018-07-12 15:21
 */
@Mapper
public interface StuInfoDao{

	/**
	 * 查询学生基本信息
	 * 
	 * @param stuNumber
	 * @return StuInfoEntity
	 */
	StuInfoEntity queryStuInfo(@Param("stuNumber") String stuNumber);

	/**
	 * 查询学生学籍信息
	 * 
	 * @param stuCode
	 * @return SchoolInfoEntity
	 */
	SchoolInfoEntity querySchoolInfo(@Param("stuCode") String stuCode);

	/**
	 * 查询学生宿舍信息
	 * 
	 * @param stuCode
	 * @return DormInfoEntity
	 */
	DormInfoEntity queryDromInfo(@Param("stuCode") String stuCode);
	
	/**
	 * 查询学生家庭信息
	 * 
	 * @param stuCode
	 * @return FamilyInfoEntity
	 */
	FamilyInfoEntity queryFamilyInfo(@Param("stuCode") String stuCode);
	
	/**
	 *根据院系专业查询学生
	 * @return
	 */
	public List<StuInfoEntity> queryStuByMajorId(StuInfoEntity stuInfoEntity);
	
	public List<StuInfoEntity> queryStuAllinfo(StuInfoEntity stuInfoEntity);
}
